<?php
include_once($_SERVER["DOCUMENT_ROOT"]."/bolsa_trabajo/util/database.php");
class GenericCombosDTO
{
	
	private static $cont  = null;

	public function __construct() {
		exit('Init function is not allowed');
	}

	public static function getGiroEmpresa(){
		$con = Database::connect();
		$query = "select * from tbl_giro_empresa";
		$stmt = $con->prepare( $query );
		$stmt->execute();
		Database::disconnect();
		return $stmt;
	}
	
	public static function getCargo(){
		$con = Database::connect();
		$query = "select id_cargo, descripcion as descripcion_cargo from tbl_cargo";
		$stmt = $con->prepare( $query );
		$stmt->execute();
		Database::disconnect();
		return $stmt;
	}
	
	public static function getRangoSalarial(){
		$con = Database::connect();
		$query = "select id_rango_salarial,descripcion as descripcion_rango_salarial from tbl_rango_salarial";
		$stmt = $con->prepare( $query );
		$stmt->execute();
		Database::disconnect();
		return $stmt;
	}
		
	public static function getAreaEmpresa(){
		$con = Database::connect();
		$query = "select id_area_empresa, nombre_area_empresa  from tbl_area_empresa";
		$stmt = $con->prepare( $query );
		$stmt->execute();
		Database::disconnect();
		return $stmt;
	}
	public static function getCarreras()
	{
		$con = Database::connect();
		$query = "SELECT * from tbl_carrera";
		$stmt = $con->prepare( $query );
		$stmt->execute();
		Database::disconnect();
		return $stmt;
	}
	
	
	public static function getNivelAcademico()
	{
		$con = Database::connect();
		$query = "SELECT * from tbl_nivel_academico";
		$stmt = $con->prepare( $query );
		$stmt->execute();
		Database::disconnect();
		return $stmt;
	}
	
	

	
	
}
?>